The following documentation contains test scripts
and expected results for validating the CDISC Builder
Findrel
tool. Do the following to verify proper
installation:
- Start CDISC Builder application by double
clicking on the desktop icon.
-
Perform each test by performing the steps specified
by the instructions.
- Evaluate the results of each step by comparing
them with results described in the Documentation
column.
| Script
|
Description
|
Documentation
|
| Source
Data |
Type
invalid path
Navigate
to location with no SAS datasets
Path
name that is longer than 200 characters
Use
[...] path navigation
|
Instructions
1
|
| Data
Sets |
List
of datasets match what is in the selected path
Verify
preview button with a separate PROC PRINT
Verify
select all button toggle.
Verify
CDISC button selection of all CDISC type datasets.
|
Instructions
2
|
| Search
Criteria |
Verify
the add of removal of search criteria.
|
Instructions
3
|
| Search
button |
Verify
the search applied on selected dataset. Verify
though a separate datastep program.
Verify
findings are listed in search results.
|
Instructions 4
|
|
Related
Domain
|
Verify
list of domains matches list in documentation.
If
CDISC dataset is selected, related domain is
defaulted.
Verify
the assignment of related domain as shown in the
assigned related domain.
|
Instructions 5
|
|
Output
|
Verify
default output file is findrel.html in the same path
of Source Data.
Verify
name that is long over 200 characters. Proper
warning message is presented.
Verify
the [...] returns the correct path
|
Instructions 6 |
| OK/Cancel |
OK
button applies all selected parameters.
Memory of all fields is retained.
Cancel
does not apply logic.
|
Instructions 7 |
| Save
Code |
Program
is saved with proper comments
Generated
program is submitted and results verified
|
Instructions 8 |
Instructions
1
Start the CDISC Builder application from the icon in
desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
Create
the following path if it does not already exist.
c:\temp\findrel\input
c:\temp\findrel\source
c:\temp\findrel\output
-
Submit
the following program:
libname testlib 'c:\temp\findrel\input';
data testlib.shoes;
set sashelp.shoes;
run;
data testlib.company;
set sashelp.company;
run;
data testlib.manage;
set sashelp.manage;
run;
-
In
FINDREL screen, input an invalid path such as:
c:\invalidpath\invalidpath
-
Hit
enter or click "OK" button, the following
message appears:
The field (Source Data) contains non-existing directory.
-
Input
path that navigate to location with no SAS datasets.
-
Click
"OK" button, verify a warning message appears:
The Data Sets list is empty.
-
Create
a temp directory named
very long name very long name very long name very long
name very long name very long name very long name very
long name very long name very long name very long name
very long name very long name very long name very long
name
-
Click
on [...] button to select that path that is longer than
200 characters.
-
Click
"OK" button.
-
There
is a message as follow:
WARNING: You cannot select a path longer than 200
characters using Select dialog. Please enter the path
directly to the Source Data field.
-
Input
that long path manually and click OK button again, verify
the warning message above no longer appears.
-
Click
[...] button next to Source Data field.
-
A
Select dialog box appears with OK and Cancel buttons.
-
Navigate
to a path that different from the old one and click
Cancel.
-
Nothing
happens.
-
Click
[...] button again and select this path 'c:\temp\findrel\input'.
-
Click
OK button, verify the path in Source Data now is 'c:\temp\findrels\input'.
Instructions
2
Start the CDISC Builder application from the icon in
desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
In
FINDREL screen, click [...] button next to Source Data
field to select this path 'c:\temp\findrel\input'
-
Verify
the Data Sets list lists all datasets in this location:
COMPANY
MANAGER
SHOES
-
From
the Data Sets list, select MANAGER dataset and click
Preview button. A report of MANAGER is created.
-
Select
more than one dataset such as COMPANY and MANAGER and
click Preview button. Verify the report now is
including Index of Datasets and Details of each
Dataset.
-
Select
all datasets in Data Sets list by click Select All button.
-
Click
Select All button again, verify all datasets in list are
deselected.
-
Click
CDISC button, verify no datasets is selected because these
datasets are not in CDISC standard.
Instructions
3
Start the CDISC Builder application from the icon
in desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
In
FINDREL screen, input 'test' value for Additional Criteria
Search.
-
Click
Add button, the 'test' value is inserted into Search
Criteria list.
-
Select
'test' item in this list and click Remove button.
Verify that this item has removed from the list.
Instructions
4
Start the CDISC Builder application from the icon
in desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
In FINDREL
screen, input 'sale' value for Additional Criteria
Search and click Add button.
-
Verify the
'sale' item is added to Search Criteria List.
-
Select
SHOES in Data Sets list and then click Search button.
-
There is
one item has been found that is SALES.
Instructions
5
Start the CDISC Builder application from the icon
in desktop.
-
Submit
the following program:
libname testlib 'c:\temp\findrel\input';
data testlib.ae(label = "Adverse Event");
set sashelp.shoes;
run;
data testlib.demog(label = "Demographics");
set sashelp.company;
run;
data testlib.co(label = "Comments");
set sashelp.manage;
run;
-
Select
FINDREL icon from the CDISC Builder screen.
-
In FINDREL
screen, verify all domains name in Related Domains list
match with ones in documentation as follow:
AE - Adverse Events
AU - Autopsy
BM - Bone Mineral Density (BMD) Data
BR - Biopsy
CM - Concomitant Meds
CO - Comments
CP - Compliance
DC - Disease Characteristics
DM - Demographics
DR - Disease Response
DS - Disposition
DV - Protocol Deviations
DY - Diary Data
EE - EEG
EG - ECG
EX - Exposure
FH - Family History
HU - Healthcare Resource Utilization
IE - Inclusion / Exclusion
IM - Imaging
LB - Laboratory Data
MB - Microbiology
MH - Medical History
ML - Meal Data
NE - Neurological Exam
OM - Organ Measurements
PC - PK Concentration
PE - Physical Exam
PP - PK Parameters
QS - Questionnaires
SC - Subject Characteristics
SE - Subject Elements
SG - Surgery
SK - Skin Test
SL - Sleep (Polysomnography) Data
SS - Signs and Symptoms
ST - Stress (Exercise) Test Data
SU - Substance Use
SV - Subject Visits
TA - Trial Arms
TE - Trial Elements
TI - Trial Inclusion/Exclusion Criteria
TV - Trial Visits Trial
VS - Vital Signs
-
Select AE
dataset in Data Sets list, verify the related domain 'AE
- Adverse Events' is selected.
-
Select
DEMOG, the related domain now is 'DM - Demographics'.
-
Repeat
again with CO dataset, verify the related domain is
changed to 'CO - Comments'.
-
Input
'sale' value for Additional Criteria Search and click
Add button.
-
Verify the
'sale' item is added to Search Criteria List.
-
Select
SHOES in Data Sets list and then click Search button.
-
There is
one item has been found that is SALES.
-
Assign
related domain for this variable by selecting a domain
name such as 'EX - Exposure' from Related Domain list
and click Assign button.
Instructions
6
Start the CDISC Builder application from the icon
in desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
Delete
value in Output field. Click Cancel button to
return CDISC Builder screen.
-
Navigate to
FINDREL screen again, verify default output file is findrel.html in
the same path of Source Data.
-
Click on
[...] button next to Output field and select a path that
is longer than 200 characters. Verify a warning
message appears as follow:
WARNING: You cannot select a path longer than 200
characters using Select dialog. Please enter the path
directly to the Output field.
Instructions
7
Start the CDISC Builder application from the icon
in desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
Input the
following information for FINDREL screen:
Source Data:
c:\temp\findrel\input
Data Sets: AE, SHOES.
Output File:
c:\temp\findrel\input\findrel.html
-
Add 'sale'
value for Search Criteria List. Click Search
button, verify there are two items displayed in Search
Results.
-
Click OK,
verify a report named 'findrel.html' is generated at c:\temp\findrel\input
that print the results have been searched.
-
Click
Cancel to close this screen. From the CDISC
Builder screen, select FINDREL again.
-
Verify that Source Data,
Related Domain and Output File contain
the information of last time.
Instructions
8
Start the CDISC Builder application from the icon
in desktop.
-
Select
FINDREL icon from the CDISC Builder screen.
-
In
FINDREL screen, input the following information:
Source Data: c:\temp\cdisc\input
Data Sets: COMPANY
-
Click
Save Code button, the Save Code screen is displayed with
default values of Path is current directory and File name
is 'findrel'.
-
Click
OK button, View Code screen shows the code of findrel macro
call.
-
Copy that code and submit it. Verify it created a
report of Finding related domain for COMPANY dataset.
For more information, please contact MXI
.
|